2015-07-07 - 20379 - Break Fix - All customers in Open order reports #CrystalReportsSupport
Break Fix
20379 - All customers in Open order reports
Problem Summary
Need to bring all customers into open order reports OSA100 and OSA180 including Retail and wholesale.
Admin Info
Purpose
|
Need to bring all customers into open order reports OSA100 and OSA180 including Retail and wholesale.
|
Requested by
|
Will Cartwright
|
Issue Date
|
07-06-2015
|
Resolved by
|
Dhananjay G
|
Resolved Date
|
07-14-2015
|
Document Status
|
Complete
|
Detailed Problem Description
Currently in OSA180 and OSA100, we are excluding intercompany customers and few EMEA retail customers. As per the requirement, NEC wants to include retail customers when ‘ALL’ is selected and exclude them when 'REGULAR' is selected.
Solution Analysis and Recommendations
BW Changes:
1. Need to remove customers exclusion in BEx queries for using both open order reports.
2. Need to collect the changes into transport request.
3. Need to check the BEx queries for QA Standards.
4. Need to unit test in BPD and transport it to BPQ for further testing.
5. Notify NEC once it is moved to BPQ and BPP.
Crystal Changes:
1. Need to add new parameter in both the open order reports for Global and Regional versions.
2. Need to follow this logic to include all intercompany and retail customers when ‘ALL’ is selected and exclude them when 'REGULAR' is selected.
3. Need to validate the data before and after conversions.
4. Need to validate the report as per NEC standard checklist.
5. Place the report in BI development and promote it to BI Production after successful validation.
Resolution
BW Changes:
1. Need to remove customers exclusion in BEx queries for using both open order reports for Global and Regional versions.
2. Need to collect the changes into transport request.
3. Need to check the BEx queries for QA Standards.
4. Need to unit test in BPD and transport it to BPQ for further testing.
5. Notify NEC once it is moved to BPQ and BPP.
BW BEx Queries Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Need to check BEx Queries against standard BEx Query checklist.
|
BEx Queries should pass all BEx Query checklist..
|
2
|
Test the Query Functionality in BPQ.
|
Query Should be successfully validated in BPQ.
|
Crystal Changes:
1. Need to add new parameter in both the open order reports for Global and Regional versions.
2. Need to follow this logic to include all intercompany and retail customers when ‘ALL’ is selected and exclude them when 'REGULAR' is selected.
3. Need to validate the data before and after conversions.
4. Need to validate the report as per NEC standard checklist.
5. Place the report in BI development and promote it to BI Production after successful validation.
Crystal Reports Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Release Information
2015-07-14 - 20379 - Rel Notes - All customers in Open order reports